UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p9PtYTmj3wNTZyWkuGueoglzV9DmuevgKv0qYS1pwC4='
WHERE
key_id = 'e5cddfc4579594cd80aa3fff9a0ed8b133546c41724d5c0abc7fc6945266b829'
AND (
token = 'p9PtYTmj3wNTZyWkuGueoglzV9DmuevgKv0qYS1pwC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)