UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2oKZUBORpsdT9rN5b4Lvlj8xhVBCoNgX2fg46kZ1WfA='
WHERE
key_id = 'aa73faa64e0e2f86fbca154868742e95c3366cbecb749cdeed1545ab2cb6d1e5'
AND (
token = '2oKZUBORpsdT9rN5b4Lvlj8xhVBCoNgX2fg46kZ1WfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)