UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCDTtSkAkgqgrnbTovN2C0wDh80uq9Q0z0BJvx2s4k0='
WHERE
key_id = 'cc8c28259083764d5684248e72ecda86243f02a38ca79c60eaa107bc5a5953ff'
AND (
token = 'bCDTtSkAkgqgrnbTovN2C0wDh80uq9Q0z0BJvx2s4k0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)