UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ndAHTIsgLa+jKjeKZ2DlRNyCLYHoLyshc2Bj05fBrew='
WHERE
key_id = 'aef838abf24654c4ac9c1fc987b0751b6e9dea65731907b03a7b14d58240ca78'
AND (
token = 'ndAHTIsgLa+jKjeKZ2DlRNyCLYHoLyshc2Bj05fBrew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)