UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qlVYHr36brErma774zB0SVFs+1HQNw90H1E1UUcQe3U='
WHERE
key_id = 'e2aafc241097d053df91afd9c03e50e7cb4016e09c5da73a30d91546ea8add5b'
AND (
token = 'qlVYHr36brErma774zB0SVFs+1HQNw90H1E1UUcQe3U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)