UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mER8i7hoKkL+Qx/55wAB470hqSsUtlEvKp9TsZYyiEE='
WHERE
key_id = 'be6309b700899ac26c3fcb0eb2d9f89fbf3f5ea38130c978bbe5e7948a4ee58e'
AND (
token = 'mER8i7hoKkL+Qx/55wAB470hqSsUtlEvKp9TsZYyiEE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)