UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Haa5Bn8W1heWI5YKfYRVREY0w4cgfGXZqjQoOfFFWrY='
WHERE
key_id = 'ea1cdff338e3ea5b236c2ef7459f9219c3773a2a5d8496452d646da30e52e7ab'
AND (
token = 'Haa5Bn8W1heWI5YKfYRVREY0w4cgfGXZqjQoOfFFWrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)