UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5oppjlm7HTN8fS8gU7yfroNwEmh2/Qv9Li47bKq+wTw='
WHERE
key_id = 'a0fc6aa7d9217511bf60ee79258532330c64c70ba63f42a5c4740212f5e09439'
AND (
token = '5oppjlm7HTN8fS8gU7yfroNwEmh2/Qv9Li47bKq+wTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)