UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W0aciaYD0Rqnbjy7RENX3+L3STLMqcImg76z1CgYFW4='
WHERE
key_id = 'e39aa99b2271c1cc26eafab4a03478bd89186d1f29afb1eda7324d8100fe1b7b'
AND (
token = 'W0aciaYD0Rqnbjy7RENX3+L3STLMqcImg76z1CgYFW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)