UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z8/+M8/iEKBjJi16mloGhw9p7Bz7+boScrthBEuKfbA='
WHERE
key_id = '900c5ff46b18c1fe6e36ba22b3b1a936296a12c670458b30525b21684799e334'
AND (
token = 'z8/+M8/iEKBjJi16mloGhw9p7Bz7+boScrthBEuKfbA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)