UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aA1F5HqalGg9GDMYNEDDsKVqx/3An/gBBRG4OaOo6yE='
WHERE
key_id = '9993b56f708416742ea7caf571f62cca68bc88663ca84a9e73191382640efd1e'
AND (
token = 'aA1F5HqalGg9GDMYNEDDsKVqx/3An/gBBRG4OaOo6yE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)