UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fxxh7yddCmm4y1rxAlpuPOYIkPHhN4I7AsnXe4Hxg2s='
WHERE
key_id = '1bbb48ba586e7108447184ebe5529cfe945afd2c0223bb97c984419b60912f04'
AND (
token = 'fxxh7yddCmm4y1rxAlpuPOYIkPHhN4I7AsnXe4Hxg2s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)