UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w1X0tgeGoSk70iggNtTq6IBT/BLOZvol95tzUi1y528='
WHERE
key_id = '506e1dd3057e604c5891c30b49811573c8761077bdf4cf91866bd461a67f3046'
AND (
token = 'w1X0tgeGoSk70iggNtTq6IBT/BLOZvol95tzUi1y528='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)