UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a7cjiEVW8fAAIk6rWx74Tfn/4edI38mrCtYj/9ye+MY='
WHERE
key_id = 'b51b9b8beed9c46e1e8e25fd346929bc44c7b24fc294b5709ffbe8c2f4cce166'
AND (
token = 'a7cjiEVW8fAAIk6rWx74Tfn/4edI38mrCtYj/9ye+MY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)