UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZG9jgvdCNVxvSdwSXNaS93eNhQuWJfkqc4ZCxvX2opM='
WHERE
key_id = 'f6034644753ed2c1470816de75b0f85e71f9fad6b84bbe2cbd33c787b017bfdd'
AND (
token = 'ZG9jgvdCNVxvSdwSXNaS93eNhQuWJfkqc4ZCxvX2opM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)