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