UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B0/a2L7IU5JXKU/p0CUvBXGkTxsNce1k456QiieoNuo='
WHERE
key_id = '822b3f04eb2c98c851fc2cbd914dd20c111ee34dddcf51923eb20d78d7701ca8'
AND (
token = 'B0/a2L7IU5JXKU/p0CUvBXGkTxsNce1k456QiieoNuo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)