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