UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '45Fig59JHBWv/UW7yv5XbDeL1DJhsOHWxD81OwFqjeE='
WHERE
key_id = '1212f7a0ea347190ffbfbd718922270890042bde2473894e81ec679ec43164de'
AND (
token = '45Fig59JHBWv/UW7yv5XbDeL1DJhsOHWxD81OwFqjeE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)