UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vD2kDw1ZNbng4B+sYuxYGcf2TfmI3RwTV1tmGeguXRI='
WHERE
key_id = '7d4244110952773475de912d48029ae6f8b70dbcf20cd541502186a55461441c'
AND (
token = 'vD2kDw1ZNbng4B+sYuxYGcf2TfmI3RwTV1tmGeguXRI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)