UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oOiLit0t+19tuCvIMIOx6ezUD8/YW8BaRFI7o/0vWQM='
WHERE
key_id = '9f49d5d3c2c6651de06ef7b1ae449383a26e2cae153b2a2cef55a25d10a1f8b8'
AND (
token = 'oOiLit0t+19tuCvIMIOx6ezUD8/YW8BaRFI7o/0vWQM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)