UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yA8oY5cm49kUu4EpL/cEnX8j0aFaQ0kayii4t+wquvE='
WHERE
key_id = '0e5e85fd10ee3b4ecd13195e51fbf98c2c0e90a4f81083c5960a36dfe87de5f9'
AND (
token = 'yA8oY5cm49kUu4EpL/cEnX8j0aFaQ0kayii4t+wquvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)