UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8BWmHLznZn1nNdpRKzVuPC+8OVmZS6KXo4+lbHdE+QI='
WHERE
key_id = 'd053c7c1886179841fc415e8a8ad320a9ab8d0b6a665df738485303dd0199e38'
AND (
token = '8BWmHLznZn1nNdpRKzVuPC+8OVmZS6KXo4+lbHdE+QI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)