UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8oQ5AKzKYUSWrvloleLr6vvjComgXIlQfdXFm5x5Hc4='
WHERE
key_id = 'c2fdb7d3e0452a1956a912158cc0d516f46aa4e2efff3be8d3c7754ae053ef63'
AND (
token = '8oQ5AKzKYUSWrvloleLr6vvjComgXIlQfdXFm5x5Hc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)