UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NwFDp9jC7LOzItBb8dxifMvV7GaHY/j24OAfx7fFAMQ='
WHERE
key_id = 'be84f7b34de828364406ad5a03b89a62d108d1e6182522f278af0f7e645fad56'
AND (
token = 'NwFDp9jC7LOzItBb8dxifMvV7GaHY/j24OAfx7fFAMQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)