UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5KH0QGm5uFdwUgsVNs+2qZYTV6/THMsC8Zhyj+r4AJY='
WHERE
key_id = '94b4902bcb8e51642c39f555318dbd5f9df35888eabb3d9fe737572472b11bfe'
AND (
token = '5KH0QGm5uFdwUgsVNs+2qZYTV6/THMsC8Zhyj+r4AJY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)