UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7xHmvGwo/4H4PI8CojymC04SPzKPbeK/7emgJCy5PZg='
WHERE
key_id = '28e452f117098370951e89883bfedb768bf7a96a6b1d338f6e1496775a157040'
AND (
token = '7xHmvGwo/4H4PI8CojymC04SPzKPbeK/7emgJCy5PZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)