UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X1WHjfxYFq89h7w/O3asZvi6+Ny7EaVBTyf54ZCzzT8='
WHERE
key_id = '6fb75daef3a2a14a086fa0b85c5b610f5d912b3b3beece61c4d97d396ff1edb2'
AND (
token = 'X1WHjfxYFq89h7w/O3asZvi6+Ny7EaVBTyf54ZCzzT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)