UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7N3krcRKDlNCldpFwpkcUEqnhqTBxfXSf5AwiTkMSd4='
WHERE
key_id = '5af5fadae9baa5a454298a330c612dc9bb35c5d953b4108e63db9ee6b6069f2d'
AND (
token = '7N3krcRKDlNCldpFwpkcUEqnhqTBxfXSf5AwiTkMSd4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)