UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DJMb9v5DjFr7CeuquMjP9WZskCMFN8dMpBHsZI24fAk='
WHERE
key_id = '3db47a7cfa72322d61eab1258dff272ff7575b4117bec4d09a16878e556caf86'
AND (
token = 'DJMb9v5DjFr7CeuquMjP9WZskCMFN8dMpBHsZI24fAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)