UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ce5iLn0F2gHNZ/+XEJj72ThAg0UDgXnlJRtfhEljH4='
WHERE
key_id = '45251dc24e29921492a32a425fc73ed2793ca544f566a0c972f8de19b05a1847'
AND (
token = '8ce5iLn0F2gHNZ/+XEJj72ThAg0UDgXnlJRtfhEljH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)