UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QTzXhzqyzD9CKydnjPOpSCcperjqREK2yd9yp/Kppcs='
WHERE
key_id = '30f3b3e5e7975bee1759436a0e1660e62c1da9536c008022ac4ace494442a7a5'
AND (
token = 'QTzXhzqyzD9CKydnjPOpSCcperjqREK2yd9yp/Kppcs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)