UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/E8SkDZeXpkRCtkM/D8/YYkTlk8I4NRTuEwlApALb2o='
WHERE
key_id = '047c66bdf3bc2d6fbdf54df8a3c22d7a66d50bc0b14100327774bd1e3afe901f'
AND (
token = '/E8SkDZeXpkRCtkM/D8/YYkTlk8I4NRTuEwlApALb2o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)