UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mqTYunEKEnHSquYGDLYy2nt3g07Eo4Re2/Z8WnMe9jw='
WHERE
key_id = 'c78cb21915e1f638035189e10840b55fbe7aab6ac9fff147ecc591af9a5ab8cd'
AND (
token = 'mqTYunEKEnHSquYGDLYy2nt3g07Eo4Re2/Z8WnMe9jw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)