UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XzWgWzUh8TU3K0AYP8WxVWdrmFobc/0lGMyj5jskU68='
WHERE
key_id = '2127d8643e5519ea58dac7e2094cc46ba87734a0682c2267233c5912f7417888'
AND (
token = 'XzWgWzUh8TU3K0AYP8WxVWdrmFobc/0lGMyj5jskU68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)