UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bkfPzp/PAOUY1+3GH8duZ7HJwbn8DW44iOasiKMbDaM='
WHERE
key_id = '05a9641a3c0bb6300e581ec1de2c8474d3ee72362ef1b2d9ecd442e0f2b1167a'
AND (
token = 'bkfPzp/PAOUY1+3GH8duZ7HJwbn8DW44iOasiKMbDaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)